import java.sql.SQLException;
import java.util.Date;
import java.util.GregorianCalendar;

import df.bean.db.conn.DBConn;
import df.bean.db.conn.DBConnection;
import df.bean.db.table.BankTMBMediaClearing;
import df.bean.db.table.Batch;
import df.bean.db.table.PaymentMonthly;
import df.bean.obj.doctor.DoctorList;
import df.bean.obj.util.DialogBox;
import df.bean.obj.util.JDate;
import df.bean.obj.util.Variables;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
import df.bean.process.ProcessBankTMBPaymentMonthly;
import df.bean.process.ProcessImport;
import df.bean.process.ProcessPaymentMonthly;
import df.bean.process.ProcessReceipt;
import df.bean.process.ProcessRollBack;
import df.bean.process.ProcessTax406;
import df.bean.process.ProcessTransDaily;
import df.bean.process.ProcessTransMonthly;

/**
 *
 * @author admin
 */
public class TestMain {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
    	//System.out.println(JDate.getDiffTimes("10/11/2009", "10/11/2009", "08:15:00", "12:00:00"));
    	DBConn d = new DBConn();
    	try {
			d.setStatement();
			System.out.println(d);
		} catch (SQLException e) {
			System.out.println(e);
		}
    	/*
    	// The date at the end of the last century /
	    Date d1 = new GregorianCalendar(2009, 11, 01, 20, 00).getTime();
	    Date d2 = new GregorianCalendar(2009, 11, 02, 06, 45).getTime();
	    // Today's date /
	    Date today = new Date();
	    double num_hour = 0.0;
	    String hour = "";
	    String min = "";
	    String text_hour = "";
	    
	    // Get msec from each, and subtract.
	    long diff = d2.getTime() - d1.getTime();
	    hour = ""+(diff / (1000 * 60 * 60));
	    min = ""+((diff / (1000 * 60))%60);
	    
	    text_hour = (diff / (1000 * 60 * 60))+"."+((diff / (1000 * 60))%60 * 100 /60);
	    num_hour = Double.parseDouble(text_hour);
	    
	    System.out.println(text_hour+" : "+num_hour);
	    System.out.println("20091101".substring(0, 4)+" , "+diff);
	    System.out.println(""+(diff / (1000 * 60 * 60 * 24))+" : "+(diff / (1000 * 60 * 60))+" : "
	        + (diff / (1000 * 60 * 60 * 24)) + " Days. "
	        + diff / (1000 * 60 * 60)+" Hours."
	        //+((diff / (1000 * 60 * 60))-((diff / (1000 * 60 * 60 * 24))*24) )+" Mins. Only "
	        +((diff / (1000 * 60))%60)+" Mins. "+((diff / (1000 * 60))%60 * 100 /60));
	    */
    }
}
